using HKB.Common;
using System;
using System.CodeDom.Compiler;
using System.ComponentModel;
using System.ComponentModel.Design;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using System.Diagnostics;
namespace HKB.Data.Dal.H_UserTableAdapters
{
	[GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0"), DataObject(true), HelpKeyword("vs.data.TableAdapter"), Designer("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"), DesignerCategory("code"), ToolboxItem(true)]
	public class HL_UserTableAdapter : Component
	{
		private SqlDataAdapter _adapter;
		private SqlConnection _connection;
		private SqlCommand[] _commandCollection;
		private bool _clearBeforeFill;
		[System.Diagnostics.DebuggerNonUserCode]
		private SqlDataAdapter Adapter
		{
			get
			{
				if (this._adapter == null)
				{
					this.InitAdapter();
				}
				return this._adapter;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		internal SqlConnection Connection
		{
			get
			{
				if (this._connection == null)
				{
					this.InitConnection();
				}
				return this._connection;
			}
			set
			{
				this._connection = value;
				if (this.Adapter.InsertCommand != null)
				{
					this.Adapter.InsertCommand.Connection = value;
				}
				if (this.Adapter.DeleteCommand != null)
				{
					this.Adapter.DeleteCommand.Connection = value;
				}
				if (this.Adapter.UpdateCommand != null)
				{
					this.Adapter.UpdateCommand.Connection = value;
				}
				for (int i = 0; i < this.CommandCollection.Length; i++)
				{
					if (this.CommandCollection[i] != null)
					{
						this.CommandCollection[i].Connection = value;
					}
				}
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		protected SqlCommand[] CommandCollection
		{
			get
			{
				if (this._commandCollection == null)
				{
					this.InitCommandCollection();
				}
				return this._commandCollection;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		public bool ClearBeforeFill
		{
			get
			{
				return this._clearBeforeFill;
			}
			set
			{
				this._clearBeforeFill = value;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		public HL_UserTableAdapter()
		{
			this.ClearBeforeFill = true;
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitAdapter()
		{
			this._adapter = new SqlDataAdapter();
			DataTableMapping dataTableMapping = new DataTableMapping();
			dataTableMapping.SourceTable = "Table";
			dataTableMapping.DataSetTable = "HL_User";
			dataTableMapping.ColumnMappings.Add("UserID", "UserID");
			dataTableMapping.ColumnMappings.Add("GroupID", "GroupID");
			dataTableMapping.ColumnMappings.Add("ClientID", "ClientID");
			dataTableMapping.ColumnMappings.Add("ContacterID", "ContacterID");
			dataTableMapping.ColumnMappings.Add("CompanyID", "CompanyID");
			dataTableMapping.ColumnMappings.Add("RssID", "RssID");
			dataTableMapping.ColumnMappings.Add("UserType", "UserType");
			dataTableMapping.ColumnMappings.Add("UserName", "UserName");
			dataTableMapping.ColumnMappings.Add("Password", "Password");
			dataTableMapping.ColumnMappings.Add("Email", "Email");
			dataTableMapping.ColumnMappings.Add("Question", "Question");
			dataTableMapping.ColumnMappings.Add("Answer", "Answer");
			dataTableMapping.ColumnMappings.Add("Sex", "Sex");
			dataTableMapping.ColumnMappings.Add("RegTime", "RegTime");
			dataTableMapping.ColumnMappings.Add("LastLoginTime", "LastLoginTime");
			dataTableMapping.ColumnMappings.Add("LastLoginIP", "LastLoginIP");
			dataTableMapping.ColumnMappings.Add("LoginTimes", "LoginTimes");
			dataTableMapping.ColumnMappings.Add("GoldCoin", "GoldCoin");
			dataTableMapping.ColumnMappings.Add("Point", "Point");
			dataTableMapping.ColumnMappings.Add("Ticket", "Ticket");
			dataTableMapping.ColumnMappings.Add("UserEP", "UserEP");
			dataTableMapping.ColumnMappings.Add("Balance", "Balance");
			dataTableMapping.ColumnMappings.Add("ConsumePoint", "ConsumePoint");
			dataTableMapping.ColumnMappings.Add("BeginTime", "BeginTime");
			dataTableMapping.ColumnMappings.Add("ValidNum", "ValidNum");
			dataTableMapping.ColumnMappings.Add("ValidUnit", "ValidUnit");
			dataTableMapping.ColumnMappings.Add("IsLocked", "IsLocked");
			dataTableMapping.ColumnMappings.Add("UnreadMsg", "UnreadMsg");
			dataTableMapping.ColumnMappings.Add("UserFriednGroup", "UserFriednGroup");
			dataTableMapping.ColumnMappings.Add("CheckNum", "CheckNum");
			dataTableMapping.ColumnMappings.Add("PassportID", "PassportID");
			dataTableMapping.ColumnMappings.Add("RssOpen", "RssOpen");
			dataTableMapping.ColumnMappings.Add("Modules", "Modules");
			dataTableMapping.ColumnMappings.Add("ShopID", "ShopID");
			dataTableMapping.ColumnMappings.Add("RegIP", "RegIP");
			dataTableMapping.ColumnMappings.Add("JoinTime", "JoinTime");
			dataTableMapping.ColumnMappings.Add("LoginIP", "LoginIP");
			dataTableMapping.ColumnMappings.Add("LoginTime", "LoginTime");
			dataTableMapping.ColumnMappings.Add("BindEmail", "BindEmail");
			dataTableMapping.ColumnMappings.Add("BindPhone", "BindPhone");
			dataTableMapping.ColumnMappings.Add("EncryptMoney", "EncryptMoney");
			this._adapter.TableMappings.Add(dataTableMapping);
			this._adapter.DeleteCommand = new SqlCommand();
			this._adapter.DeleteCommand.Connection = this.Connection;
			this._adapter.DeleteCommand.CommandText = "DELETE FROM [HL_User] WHERE (([UserID] = @Original_UserID))";
			this._adapter.DeleteCommand.CommandType = CommandType.Text;
			this._adapter.DeleteCommand.Parameters.Add(new SqlParameter("@Original_UserID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "UserID", DataRowVersion.Original, false, null, "", "", ""));
			this._adapter.InsertCommand = new SqlCommand();
			this._adapter.InsertCommand.Connection = this.Connection;
			this._adapter.InsertCommand.CommandText = "INSERT INTO [HL_User] ([GroupID], [ClientID], [ContacterID], [CompanyID], [RssID], [UserType], [UserName], [Password], [Email], [Question], [Answer], [RegTime], [LastLoginTime], [LastLoginIP], [LoginTimes], [GoldCoin], [Point], [Ticket], [UserEP], [Balance], [ConsumePoint], [BeginTime], [ValidNum], [ValidUnit], [IsLocked], [UnreadMsg], [UserFriednGroup], [CheckNum], [PassportID], [RssOpen], [Modules], [ShopID], [Sex], [RegIP], [JoinTime], [LoginIP], [LoginTime], [BindEmail], [BindPhone], [EncryptMoney]) VALUES (@GroupID, @ClientID, @ContacterID, @CompanyID, @RssID, @UserType, @UserName, @Password, @Email, @Question, @Answer, @RegTime, @LastLoginTime, @LastLoginIP, @LoginTimes, @GoldCoin, @Point, @Ticket, @UserEP, @Balance, @ConsumePoint, @BeginTime, @ValidNum, @ValidUnit, @IsLocked, @UnreadMsg, @UserFriednGroup, @CheckNum, @PassportID, @RssOpen, @Modules, @ShopID, @Sex, @RegIP, @JoinTime, @LoginIP, @LoginTime, @BindEmail, @BindPhone, @EncryptMoney)";
			this._adapter.InsertCommand.CommandType = CommandType.Text;
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@GroupID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "GroupID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ClientID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ClientID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ContacterID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ContacterID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@CompanyID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "CompanyID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@RssID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "RssID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@UserType", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "UserType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@UserName", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "UserName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Password", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Password", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Email", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Email", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Question", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Question", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Answer", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Answer", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@RegTime", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "RegTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@LastLoginTime", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "LastLoginTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@LastLoginIP", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "LastLoginIP", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@LoginTimes", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "LoginTimes", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@GoldCoin", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "GoldCoin", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Point", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Point", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Ticket", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Ticket", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@UserEP", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "UserEP", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Balance", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "Balance", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ConsumePoint", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ConsumePoint", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@BeginTime", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "BeginTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ValidNum", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ValidNum", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ValidUnit", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ValidUnit", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@IsLocked", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "IsLocked", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@UnreadMsg", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "UnreadMsg", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@UserFriednGroup", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "UserFriednGroup", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@CheckNum", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "CheckNum", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PassportID", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "PassportID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@RssOpen", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "RssOpen", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Modules", SqlDbType.Text, 0, ParameterDirection.Input, 0, 0, "Modules", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Sex", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Sex", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@RegIP", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "RegIP", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@JoinTime", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "JoinTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@LoginIP", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "LoginIP", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@LoginTime", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "LoginTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@BindEmail", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "BindEmail", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@BindPhone", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "BindPhone", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@EncryptMoney", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "EncryptMoney", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand = new SqlCommand();
			this._adapter.UpdateCommand.Connection = this.Connection;
			this._adapter.UpdateCommand.CommandText = "UPDATE [HL_User] SET [GroupID] = @GroupID, [ClientID] = @ClientID, [ContacterID] = @ContacterID, [CompanyID] = @CompanyID, [RssID] = @RssID, [UserType] = @UserType, [UserName] = @UserName, [Password] = @Password, [Email] = @Email, [Question] = @Question, [Answer] = @Answer, [RegTime] = @RegTime, [LastLoginTime] = @LastLoginTime, [LastLoginIP] = @LastLoginIP, [LoginTimes] = @LoginTimes, [GoldCoin] = @GoldCoin, [Point] = @Point, [Ticket] = @Ticket, [UserEP] = @UserEP, [Balance] = @Balance, [ConsumePoint] = @ConsumePoint, [BeginTime] = @BeginTime, [ValidNum] = @ValidNum, [ValidUnit] = @ValidUnit, [IsLocked] = @IsLocked, [UnreadMsg] = @UnreadMsg, [UserFriednGroup] = @UserFriednGroup, [CheckNum] = @CheckNum, [PassportID] = @PassportID, [RssOpen] = @RssOpen, [Modules] = @Modules, [ShopID] = @ShopID, [Sex] = @Sex, [RegIP] = @RegIP, [JoinTime] = @JoinTime, [LoginIP] = @LoginIP, [LoginTime] = @LoginTime, [BindEmail] = @BindEmail, [BindPhone] = @BindPhone, [EncryptMoney] = @EncryptMoney WHERE (([UserID] = @Original_UserID))";
			this._adapter.UpdateCommand.CommandType = CommandType.Text;
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@GroupID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "GroupID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ClientID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ClientID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ContacterID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ContacterID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@CompanyID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "CompanyID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@RssID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "RssID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@UserType", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "UserType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@UserName", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "UserName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Password", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Password", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Email", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Email", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Question", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Question", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Answer", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Answer", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@RegTime", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "RegTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@LastLoginTime", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "LastLoginTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@LastLoginIP", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "LastLoginIP", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@LoginTimes", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "LoginTimes", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@GoldCoin", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "GoldCoin", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Point", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Point", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Ticket", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Ticket", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@UserEP", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "UserEP", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Balance", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "Balance", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ConsumePoint", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ConsumePoint", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@BeginTime", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "BeginTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ValidNum", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ValidNum", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ValidUnit", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ValidUnit", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@IsLocked", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "IsLocked", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@UnreadMsg", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "UnreadMsg", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@UserFriednGroup", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "UserFriednGroup", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@CheckNum", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "CheckNum", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PassportID", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "PassportID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@RssOpen", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "RssOpen", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Modules", SqlDbType.Text, 0, ParameterDirection.Input, 0, 0, "Modules", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Sex", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Sex", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@RegIP", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "RegIP", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@JoinTime", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "JoinTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@LoginIP", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "LoginIP", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@LoginTime", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "LoginTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@BindEmail", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "BindEmail", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@BindPhone", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "BindPhone", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@EncryptMoney", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "EncryptMoney", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Original_UserID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "UserID", DataRowVersion.Original, false, null, "", "", ""));
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitConnection()
		{
			this._connection = new SqlConnection();
			this._connection.ConnectionString = Conn.CurrenConnectionStrings;
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitCommandCollection()
		{
			this._commandCollection = new SqlCommand[22];
			this._commandCollection[0] = new SqlCommand();
			this._commandCollection[0].Connection = this.Connection;
			this._commandCollection[0].CommandText = "SELECT UserID, GroupID, ClientID, ContacterID, CompanyID, RssID, UserType, UserName, \r\n      Password, Email, Question, Answer, RegTime, LastLoginTime, LastLoginIP, \r\n      LoginTimes, GoldCoin, Point, Ticket, UserEP, Balance, ConsumePoint, BeginTime, \r\n      ValidNum, ValidUnit, IsLocked, UnreadMsg, UserFriednGroup, CheckNum, PassportID, \r\n      RssOpen, Modules, ShopID, Sex, RegIP, JoinTime, LoginIP, LoginTime, BindEmail, \r\n      BindPhone, EncryptMoney\r\nFROM HL_User\r\nORDER BY UserID DESC";
			this._commandCollection[0].CommandType = CommandType.Text;
			this._commandCollection[1] = new SqlCommand();
			this._commandCollection[1].Connection = this.Connection;
			this._commandCollection[1].CommandText = "pr_AddUser";
			this._commandCollection[1].CommandType = CommandType.StoredProcedure;
			this._commandCollection[1].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@UserName", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@UserPassword", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@UserEmail", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@UserAnswer", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@UserQuestion", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@GroupID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Sex", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@LastLoginIP", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@GoldCoin", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Points", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Ticket", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@UserExp", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@CheckNum", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@ClientID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@ContacterID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@UserType", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@CompanyID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@RssID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@RegTime", SqlDbType.DateTime, 8, ParameterDirection.Input, 23, 3, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@JoinTime", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@IsLocked", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@PassportID", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@RssOpen", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@RegIP", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@SendMsg", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[2] = new SqlCommand();
			this._commandCollection[2].Connection = this.Connection;
			this._commandCollection[2].CommandText = "SELECT COUNT(UserID) FROM HL_User Where Email=@Email";
			this._commandCollection[2].CommandType = CommandType.Text;
			this._commandCollection[2].Parameters.Add(new SqlParameter("@Email", SqlDbType.NVarChar, 50, ParameterDirection.Input, 0, 0, "Email", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[3] = new SqlCommand();
			this._commandCollection[3].Connection = this.Connection;
			this._commandCollection[3].CommandText = "SELECT COUNT(UserID) FROM HL_User Where UserName=@UserName";
			this._commandCollection[3].CommandType = CommandType.Text;
			this._commandCollection[3].Parameters.Add(new SqlParameter("@UserName", SqlDbType.NVarChar, 50, ParameterDirection.Input, 0, 0, "UserName", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[4] = new SqlCommand();
			this._commandCollection[4].Connection = this.Connection;
			this._commandCollection[4].CommandText = "SELECT COUNT(UserID) As OnLine FROM HL_User WHERE LoginTime< GetDate() AND LoginTime>DATEADD(dd,-1,GetDate())";
			this._commandCollection[4].CommandType = CommandType.Text;
			this._commandCollection[5] = new SqlCommand();
			this._commandCollection[5].Connection = this.Connection;
			this._commandCollection[5].CommandText = "pr_DeleteUser";
			this._commandCollection[5].CommandType = CommandType.StoredProcedure;
			this._commandCollection[5].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[5].Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[6] = new SqlCommand();
			this._commandCollection[6].Connection = this.Connection;
			this._commandCollection[6].CommandText = "SELECT top 1 *\r\nFROM HL_User\r\nWhere UserName=@UserName and Password=@Password";
			this._commandCollection[6].CommandType = CommandType.Text;
			this._commandCollection[6].Parameters.Add(new SqlParameter("@UserName", SqlDbType.NVarChar, 50, ParameterDirection.Input, 0, 0, "UserName", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[6].Parameters.Add(new SqlParameter("@Password", SqlDbType.NVarChar, 50, ParameterDirection.Input, 0, 0, "Password", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[7] = new SqlCommand();
			this._commandCollection[7].Connection = this.Connection;
			this._commandCollection[7].CommandText = "SELECT HL_User.UserID, HL_User.GroupID, HL_User.ClientID, HL_User.ContacterID, \r\n      HL_User.CompanyID, HL_User.RssID, HL_User.UserType, HL_User.UserName, \r\n      HL_User.Password, HL_User.Email, HL_User.Question, HL_User.Answer, \r\n      HL_User.RegTime, HL_User.LastLoginTime, HL_User.LastLoginIP, \r\n      HL_User.LoginTimes, HL_User.GoldCoin, HL_User.Point, HL_User.Ticket, \r\n      HL_User.UserEP, HL_User.Balance, HL_User.ConsumePoint, HL_User.BeginTime, \r\n      HL_User.ValidNum, HL_User.ValidUnit, HL_User.IsLocked, HL_User.UnreadMsg, \r\n      HL_User.UserFriednGroup, HL_User.CheckNum, HL_User.PassportID, \r\n      HL_User.RssOpen, HL_User.Modules, HL_User.ShopID, HL_User.Sex, \r\n      HL_User.RegIP, HL_User.JoinTime, HL_User.LoginIP, HL_User.LoginTime, \r\n      HL_User.BindEmail, HL_User.BindPhone, HL_User.EncryptMoney, \r\n      HL_Group.GroupType, HL_Group.GroupName\r\nFROM HL_User INNER JOIN\r\n      HL_Group ON HL_User.GroupID = HL_Group.GroupID\r\nORDER BY HL_User.UserID DESC";
			this._commandCollection[7].CommandType = CommandType.Text;
			this._commandCollection[8] = new SqlCommand();
			this._commandCollection[8].Connection = this.Connection;
			this._commandCollection[8].CommandText = "SELECT UserID, GroupID, ClientID, ContacterID, CompanyID, RssID, UserType, UserName, \r\n      Password, Email, Question, Answer, RegTime, LastLoginTime, LastLoginIP, \r\n      LoginTimes, GoldCoin, Point, Ticket, UserEP, Balance, ConsumePoint, BeginTime, \r\n      ValidNum, ValidUnit, IsLocked, UnreadMsg, UserFriednGroup, CheckNum, PassportID, \r\n      RssOpen, Modules, ShopID, Sex, RegIP, JoinTime, LoginIP, LoginTime, BindEmail, \r\n      BindPhone\r\nFROM HL_User\r\nWHERE Email=@Email\r\nOrder By UserID Desc";
			this._commandCollection[8].CommandType = CommandType.Text;
			this._commandCollection[8].Parameters.Add(new SqlParameter("@Email", SqlDbType.NVarChar, 50, ParameterDirection.Input, 0, 0, "Email", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[9] = new SqlCommand();
			this._commandCollection[9].Connection = this.Connection;
			this._commandCollection[9].CommandText = "SELECT HL_User.Answer, HL_User.Balance, HL_User.BeginTime, HL_User.BindEmail, \r\n      HL_User.BindPhone, HL_User.CheckNum, HL_User.ClientID, HL_User.CompanyID, \r\n      HL_User.ConsumePoint, HL_User.ContacterID, HL_User.Email, HL_User.GoldCoin, \r\n      HL_User.GroupID, HL_User.IsLocked, HL_User.JoinTime, HL_User.LastLoginIP, \r\n      HL_User.LastLoginTime, HL_User.LoginIP, HL_User.LoginTime, \r\n      HL_User.LoginTimes, HL_User.Modules, HL_User.PassportID, HL_User.Password, \r\n      HL_User.Point, HL_User.Question, HL_User.RegIP, HL_User.RegTime, \r\n      HL_User.RssID, HL_User.RssOpen, HL_User.Sex, HL_User.ShopID, HL_User.Ticket, \r\n      HL_User.UnreadMsg, HL_User.UserEP, HL_User.UserFriednGroup, HL_User.UserID, \r\n      HL_User.UserName, HL_User.UserType, HL_User.ValidNum, HL_User.ValidUnit, \r\n      HL_Group.GroupName\r\nFROM HL_User INNER JOIN\r\n      HL_Group ON HL_User.GroupID = HL_Group.GroupID\r\nWHERE (HL_User.GoldCoin = 0)";
			this._commandCollection[9].CommandType = CommandType.Text;
			this._commandCollection[10] = new SqlCommand();
			this._commandCollection[10].Connection = this.Connection;
			this._commandCollection[10].CommandText = "SELECT HL_User.UserID, HL_User.ClientID, HL_User.ContacterID, HL_User.CompanyID, \r\n      HL_User.RssID, HL_User.UserType, HL_User.UserName, HL_User.Password, \r\n      HL_User.Email, HL_User.Question, HL_User.Answer, HL_User.RegTime, \r\n      HL_User.LastLoginTime, HL_User.LastLoginIP, HL_User.LoginTimes, \r\n      HL_User.GoldCoin, HL_User.Point, HL_User.Ticket, HL_User.UserEP, \r\n      HL_User.Balance, HL_User.ConsumePoint, HL_User.BeginTime, HL_User.ValidNum, \r\n      HL_User.ValidUnit, HL_User.IsLocked, HL_User.UnreadMsg, \r\n      HL_User.UserFriednGroup, HL_User.CheckNum, HL_User.PassportID, \r\n      HL_User.RssOpen, HL_User.Modules, HL_User.ShopID, HL_User.Sex, \r\n      HL_User.RegIP, HL_User.JoinTime, HL_User.LoginIP, HL_User.LoginTime, \r\n      HL_User.BindEmail, HL_User.BindPhone, HL_User.EncryptMoney, \r\n      HL_Group.GroupName, HL_Group.GroupID\r\nFROM HL_User INNER JOIN\r\n      HL_Group ON HL_User.GroupID = HL_Group.GroupID\r\nWHERE (HL_Group.GroupType = @GroupType)\r\nORDER BY HL_User.UserID DESC";
			this._commandCollection[10].CommandType = CommandType.Text;
			this._commandCollection[10].Parameters.Add(new SqlParameter("@GroupType", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "GroupType", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[11] = new SqlCommand();
			this._commandCollection[11].Connection = this.Connection;
			this._commandCollection[11].CommandText = "SELECT Answer, Balance, BeginTime, BindEmail, BindPhone, CheckNum, ClientID, CompanyID, ConsumePoint, ContacterID, Email, GoldCoin, GroupID, IsLocked, JoinTime, LastLoginIP, LastLoginTime, LoginIP, LoginTime, LoginTimes, Modules, PassportID, Password, Point, Question, RegIP, RegTime, RssID, RssOpen, Sex, ShopID, Ticket, UnreadMsg, UserEP, UserFriednGroup, UserID, UserName, UserType, ValidNum, ValidUnit ,EncryptMoney FROM HL_User WHERE (UserID = @UserID)";
			this._commandCollection[11].CommandType = CommandType.Text;
			this._commandCollection[11].Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[12] = new SqlCommand();
			this._commandCollection[12].Connection = this.Connection;
			this._commandCollection[12].CommandText = "SELECT HL_User.Answer, HL_User.Balance, HL_User.BeginTime, HL_User.BindEmail, \r\n      HL_User.BindPhone, HL_User.CheckNum, HL_User.ClientID, HL_User.CompanyID, \r\n      HL_User.ConsumePoint, HL_User.ContacterID, HL_User.Email, HL_User.GoldCoin, \r\n      HL_User.GroupID, HL_User.IsLocked, HL_User.JoinTime, HL_User.LastLoginIP, \r\n      HL_User.LastLoginTime, HL_User.LoginIP, HL_User.LoginTime, \r\n      HL_User.LoginTimes, HL_User.Modules, HL_User.PassportID, HL_User.Password, \r\n      HL_User.Point, HL_User.Question, HL_User.RegIP, HL_User.RegTime, \r\n      HL_User.RssID, HL_User.RssOpen, HL_User.Sex, HL_User.ShopID, HL_User.Ticket, \r\n      HL_User.UnreadMsg, HL_User.UserEP, HL_User.UserFriednGroup, HL_User.UserID, \r\n      HL_User.UserName, HL_User.UserType, HL_User.ValidNum, HL_User.ValidUnit, \r\n      HL_Group.GroupName\r\nFROM HL_User INNER JOIN\r\n      HL_Group ON HL_User.GroupID = HL_Group.GroupID\r\nWHERE (HL_User.UserName = @UserName)";
			this._commandCollection[12].CommandType = CommandType.Text;
			this._commandCollection[12].Parameters.Add(new SqlParameter("@UserName", SqlDbType.NVarChar, 50, ParameterDirection.Input, 0, 0, "UserName", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13] = new SqlCommand();
			this._commandCollection[13].Connection = this.Connection;
			this._commandCollection[13].CommandText = "PR_GetUserGetGroupGetShopUserInfoByUserNamePass";
			this._commandCollection[13].CommandType = CommandType.StoredProcedure;
			this._commandCollection[13].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@UserName", SqlDbType.NVarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@Password", SqlDbType.NVarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14] = new SqlCommand();
			this._commandCollection[14].Connection = this.Connection;
			this._commandCollection[14].CommandText = "SELECT Answer, Balance, BeginTime, BindEmail, BindPhone, CheckNum, ClientID, CompanyID, ConsumePoint, ContacterID, Email, GoldCoin, GroupID, IsLocked, JoinTime, LastLoginIP, LastLoginTime, LoginIP, LoginTime, LoginTimes, Modules, PassportID, Password, Point, Question, RegIP, RegTime, RssID, RssOpen, Sex, ShopID, Ticket, UnreadMsg, UserEP, UserFriednGroup, UserID, UserName, UserType, ValidNum, ValidUnit FROM HL_User WHERE (Email = @Email)";
			this._commandCollection[14].CommandType = CommandType.Text;
			this._commandCollection[14].Parameters.Add(new SqlParameter("@Email", SqlDbType.NVarChar, 50, ParameterDirection.Input, 0, 0, "Email", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15] = new SqlCommand();
			this._commandCollection[15].Connection = this.Connection;
			this._commandCollection[15].CommandText = "SELECT Answer, Balance, BeginTime, BindEmail, BindPhone, CheckNum, ClientID, CompanyID, ConsumePoint, ContacterID, Email, GoldCoin, GroupID, IsLocked, JoinTime, LastLoginIP, LastLoginTime, LoginIP, LoginTime, LoginTimes, Modules, PassportID, Password, Point, Question, RegIP, RegTime, RssID, RssOpen, Sex, ShopID, Ticket, UnreadMsg, UserEP, UserFriednGroup, UserID, UserName, UserType, ValidNum, ValidUnit FROM HL_User WHERE (UserName = @UserName)";
			this._commandCollection[15].CommandType = CommandType.Text;
			this._commandCollection[15].Parameters.Add(new SqlParameter("@UserName", SqlDbType.NVarChar, 50, ParameterDirection.Input, 0, 0, "UserName", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[16] = new SqlCommand();
			this._commandCollection[16].Connection = this.Connection;
			this._commandCollection[16].CommandText = "SELECT HL_User.Answer, HL_User.Balance, HL_User.BeginTime, HL_User.BindEmail, \r\n      HL_User.BindPhone, HL_User.CheckNum, HL_User.ClientID, HL_User.CompanyID, \r\n      HL_User.ConsumePoint, HL_User.ContacterID, HL_User.Email, HL_User.GoldCoin, \r\n      HL_User.GroupID, HL_User.IsLocked, HL_User.JoinTime, HL_User.LastLoginIP, \r\n      HL_User.LastLoginTime, HL_User.LoginIP, HL_User.LoginTime, \r\n      HL_User.LoginTimes, HL_User.Modules, HL_User.PassportID, HL_User.Password, \r\n      HL_User.Point, HL_User.Question, HL_User.RegIP, HL_User.RegTime, \r\n      HL_User.RssID, HL_User.RssOpen, HL_User.Sex, HL_User.ShopID, HL_User.Ticket, \r\n      HL_User.UnreadMsg, HL_User.UserEP, HL_User.UserFriednGroup, HL_User.UserID, \r\n      HL_User.UserName, HL_User.UserType, HL_User.ValidNum, HL_User.ValidUnit, \r\n      HL_Group.GroupName\r\nFROM HL_User INNER JOIN\r\n      HL_Group ON HL_User.GroupID = HL_Group.GroupID\r\nWHERE (HL_User.UserName LIKE '%' + @UserName + '%')";
			this._commandCollection[16].CommandType = CommandType.Text;
			this._commandCollection[16].Parameters.Add(new SqlParameter("@UserName", SqlDbType.NVarChar, 50, ParameterDirection.Input, 0, 0, "UserName", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[17] = new SqlCommand();
			this._commandCollection[17].Connection = this.Connection;
			this._commandCollection[17].CommandText = "SELECT UserID,GoldCoin, Point, Ticket, UserEP, Balance, ConsumePoint, BeginTime, \r\n      ValidNum, ValidUnit, IsLocked\r\nFROM HL_User\r\nWHERE UserID=@UserID\r\n";
			this._commandCollection[17].CommandType = CommandType.Text;
			this._commandCollection[17].Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[18] = new SqlCommand();
			this._commandCollection[18].Connection = this.Connection;
			this._commandCollection[18].CommandText = "PR_PageListForAdmin";
			this._commandCollection[18].CommandType = CommandType.StoredProcedure;
			this._commandCollection[18].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[18].Parameters.Add(new SqlParameter("@tblName", SqlDbType.VarChar, 255, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[18].Parameters.Add(new SqlParameter("@strGetFields", SqlDbType.VarChar, 1000, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[18].Parameters.Add(new SqlParameter("@fldName", SqlDbType.VarChar, 255, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[18].Parameters.Add(new SqlParameter("@PageSize", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[18].Parameters.Add(new SqlParameter("@PageIndex", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[18].Parameters.Add(new SqlParameter("@OrderType", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[18].Parameters.Add(new SqlParameter("@strWhere", SqlDbType.VarChar, 1500, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[18].Parameters.Add(new SqlParameter("@Counts", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[19] = new SqlCommand();
			this._commandCollection[19].Connection = this.Connection;
			this._commandCollection[19].CommandText = "SELECT HL_User.Answer, HL_User.Balance, HL_User.BeginTime, HL_User.BindEmail, \r\n      HL_User.BindPhone, HL_User.CheckNum, HL_User.ClientID, HL_User.CompanyID, \r\n      HL_User.ConsumePoint, HL_User.ContacterID, HL_User.Email, HL_User.GoldCoin, \r\n      HL_User.IsLocked, HL_User.JoinTime, HL_User.LastLoginIP, \r\n      HL_User.LastLoginTime, HL_User.LoginIP, HL_User.LoginTime, \r\n      HL_User.LoginTimes, HL_User.Modules, HL_User.PassportID, HL_User.Password, \r\n      HL_User.Point, HL_User.Question, HL_User.RegIP, HL_User.RegTime, \r\n      HL_User.RssID, HL_User.RssOpen, HL_User.Sex, HL_User.ShopID, HL_User.Ticket, \r\n      HL_User.UnreadMsg, HL_User.UserEP, HL_User.UserFriednGroup, HL_User.UserID, \r\n      HL_User.UserName, HL_User.UserType, HL_User.ValidNum, HL_User.ValidUnit, \r\n      HL_Group.GroupID \r\nFROM HL_User INNER JOIN\r\n      HL_Group ON HL_User.GroupID = HL_Group.GroupID\r\nWHERE (HL_User.GroupID = @GroupID)\r\nORDER BY HL_User.UserID DESC";
			this._commandCollection[19].CommandType = CommandType.Text;
			this._commandCollection[19].Parameters.Add(new SqlParameter("@GroupID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "GroupID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[20] = new SqlCommand();
			this._commandCollection[20].Connection = this.Connection;
			this._commandCollection[20].CommandText = "PR_AdminUser";
			this._commandCollection[20].CommandType = CommandType.StoredProcedure;
			this._commandCollection[20].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[20].Parameters.Add(new SqlParameter("@UserIDArray", SqlDbType.VarChar, 300, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[20].Parameters.Add(new SqlParameter("@Type", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[21] = new SqlCommand();
			this._commandCollection[21].Connection = this.Connection;
			this._commandCollection[21].CommandText = "PR_UpdatePayMoney";
			this._commandCollection[21].CommandType = CommandType.StoredProcedure;
			this._commandCollection[21].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[21].Parameters.Add(new SqlParameter("@OrderFormID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[21].Parameters.Add(new SqlParameter("@BuyerID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[21].Parameters.Add(new SqlParameter("@SalerID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[21].Parameters.Add(new SqlParameter("@PayMoney", SqlDbType.Decimal, 9, ParameterDirection.Input, 18, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[21].Parameters.Add(new SqlParameter("@Sender_moneyKey", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[21].Parameters.Add(new SqlParameter("@Receiver_moneyKey", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
		}
		[DataObjectMethod(DataObjectMethodType.Select, true), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_User.HL_UserDataTable GetAllUsers()
		{
			this.Adapter.SelectCommand = this.CommandCollection[0];
			H_User.HL_UserDataTable hL_UserDataTable = new H_User.HL_UserDataTable();
			this.Adapter.Fill(hL_UserDataTable);
			return hL_UserDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_User.HL_UserDataTable AddNewUserAndGetUserID(string UserName, string UserPassword, string UserEmail, string UserAnswer, string UserQuestion, int? GroupID, int? Sex, string LastLoginIP, int? GoldCoin, int? Points, int? Ticket, int? UserExp, string CheckNum, int? ClientID, int? ContacterID, string UserType, int? CompanyID, int? RssID, System.DateTime? RegTime, string JoinTime, int? IsLocked, string PassportID, int? RssOpen, string RegIP, int? SendMsg)
		{
			this.Adapter.SelectCommand = this.CommandCollection[1];
			if (UserName == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = UserName;
			}
			if (UserPassword == null)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = UserPassword;
			}
			if (UserEmail == null)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = UserEmail;
			}
			if (UserAnswer == null)
			{
				this.Adapter.SelectCommand.Parameters[4].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[4].Value = UserAnswer;
			}
			if (UserQuestion == null)
			{
				this.Adapter.SelectCommand.Parameters[5].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[5].Value = UserQuestion;
			}
			if (GroupID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[6].Value = GroupID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[6].Value = System.DBNull.Value;
			}
			if (Sex.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[7].Value = Sex.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[7].Value = System.DBNull.Value;
			}
			if (LastLoginIP == null)
			{
				this.Adapter.SelectCommand.Parameters[8].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[8].Value = LastLoginIP;
			}
			if (GoldCoin.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[9].Value = GoldCoin.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[9].Value = System.DBNull.Value;
			}
			if (Points.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[10].Value = Points.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[10].Value = System.DBNull.Value;
			}
			if (Ticket.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[11].Value = Ticket.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[11].Value = System.DBNull.Value;
			}
			if (UserExp.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[12].Value = UserExp.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[12].Value = System.DBNull.Value;
			}
			if (CheckNum == null)
			{
				this.Adapter.SelectCommand.Parameters[13].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[13].Value = CheckNum;
			}
			if (ClientID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[14].Value = ClientID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[14].Value = System.DBNull.Value;
			}
			if (ContacterID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[15].Value = ContacterID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[15].Value = System.DBNull.Value;
			}
			if (UserType == null)
			{
				this.Adapter.SelectCommand.Parameters[16].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[16].Value = UserType;
			}
			if (CompanyID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[17].Value = CompanyID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[17].Value = System.DBNull.Value;
			}
			if (RssID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[18].Value = RssID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[18].Value = System.DBNull.Value;
			}
			if (RegTime.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[19].Value = RegTime.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[19].Value = System.DBNull.Value;
			}
			if (JoinTime == null)
			{
				this.Adapter.SelectCommand.Parameters[20].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[20].Value = JoinTime;
			}
			if (IsLocked.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[21].Value = IsLocked.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[21].Value = System.DBNull.Value;
			}
			if (PassportID == null)
			{
				this.Adapter.SelectCommand.Parameters[22].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[22].Value = PassportID;
			}
			if (RssOpen.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[23].Value = RssOpen.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[23].Value = System.DBNull.Value;
			}
			if (RegIP == null)
			{
				this.Adapter.SelectCommand.Parameters[24].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[24].Value = RegIP;
			}
			if (SendMsg.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[25].Value = SendMsg.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[25].Value = System.DBNull.Value;
			}
			H_User.HL_UserDataTable hL_UserDataTable = new H_User.HL_UserDataTable();
			this.Adapter.Fill(hL_UserDataTable);
			return hL_UserDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_User.HL_UserDataTable DeleteUser(int? UserID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[5];
			if (UserID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = UserID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			H_User.HL_UserDataTable hL_UserDataTable = new H_User.HL_UserDataTable();
			this.Adapter.Fill(hL_UserDataTable);
			return hL_UserDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_User.HL_UserDataTable GetUserByUserNamePassword(string UserName, string Password)
		{
			this.Adapter.SelectCommand = this.CommandCollection[6];
			if (UserName == null)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = UserName;
			}
			if (Password == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = Password;
			}
			H_User.HL_UserDataTable hL_UserDataTable = new H_User.HL_UserDataTable();
			this.Adapter.Fill(hL_UserDataTable);
			return hL_UserDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_User.HL_UserDataTable GetAllGroupUser()
		{
			this.Adapter.SelectCommand = this.CommandCollection[7];
			H_User.HL_UserDataTable hL_UserDataTable = new H_User.HL_UserDataTable();
			this.Adapter.Fill(hL_UserDataTable);
			return hL_UserDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_User.HL_UserDataTable GetUserByEmail(string Email)
		{
			this.Adapter.SelectCommand = this.CommandCollection[8];
			if (Email == null)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = Email;
			}
			H_User.HL_UserDataTable hL_UserDataTable = new H_User.HL_UserDataTable();
			this.Adapter.Fill(hL_UserDataTable);
			return hL_UserDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_User.HL_UserDataTable GetUserByGoldCoin()
		{
			this.Adapter.SelectCommand = this.CommandCollection[9];
			H_User.HL_UserDataTable hL_UserDataTable = new H_User.HL_UserDataTable();
			this.Adapter.Fill(hL_UserDataTable);
			return hL_UserDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_User.HL_UserDataTable GetUserByGroupType(int? GroupType)
		{
			this.Adapter.SelectCommand = this.CommandCollection[10];
			if (GroupType.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = GroupType.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			H_User.HL_UserDataTable hL_UserDataTable = new H_User.HL_UserDataTable();
			this.Adapter.Fill(hL_UserDataTable);
			return hL_UserDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_User.HL_UserDataTable GetUserByUserID(int UserID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[11];
			this.Adapter.SelectCommand.Parameters[0].Value = UserID;
			H_User.HL_UserDataTable hL_UserDataTable = new H_User.HL_UserDataTable();
			this.Adapter.Fill(hL_UserDataTable);
			return hL_UserDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_User.HL_UserDataTable GetUserByUserName(string UserName)
		{
			this.Adapter.SelectCommand = this.CommandCollection[12];
			if (UserName == null)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = UserName;
			}
			H_User.HL_UserDataTable hL_UserDataTable = new H_User.HL_UserDataTable();
			this.Adapter.Fill(hL_UserDataTable);
			return hL_UserDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_User.HL_UserDataTable GetUserGetGroupGetShopUserInfoByNamePass(string UserName, string Password)
		{
			this.Adapter.SelectCommand = this.CommandCollection[13];
			if (UserName == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = UserName;
			}
			if (Password == null)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = Password;
			}
			H_User.HL_UserDataTable hL_UserDataTable = new H_User.HL_UserDataTable();
			this.Adapter.Fill(hL_UserDataTable);
			return hL_UserDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_User.HL_UserDataTable GetUserIDByEmail(string Email)
		{
			this.Adapter.SelectCommand = this.CommandCollection[14];
			if (Email == null)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = Email;
			}
			H_User.HL_UserDataTable hL_UserDataTable = new H_User.HL_UserDataTable();
			this.Adapter.Fill(hL_UserDataTable);
			return hL_UserDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_User.HL_UserDataTable GetUserIDByUserName(string UserName)
		{
			this.Adapter.SelectCommand = this.CommandCollection[15];
			if (UserName == null)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = UserName;
			}
			H_User.HL_UserDataTable hL_UserDataTable = new H_User.HL_UserDataTable();
			this.Adapter.Fill(hL_UserDataTable);
			return hL_UserDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_User.HL_UserDataTable GetUserLikeUserName(string UserName)
		{
			this.Adapter.SelectCommand = this.CommandCollection[16];
			if (UserName == null)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = UserName;
			}
			H_User.HL_UserDataTable hL_UserDataTable = new H_User.HL_UserDataTable();
			this.Adapter.Fill(hL_UserDataTable);
			return hL_UserDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_User.HL_UserDataTable GetUserMoneyByUserID(int UserID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[17];
			this.Adapter.SelectCommand.Parameters[0].Value = UserID;
			H_User.HL_UserDataTable hL_UserDataTable = new H_User.HL_UserDataTable();
			this.Adapter.Fill(hL_UserDataTable);
			return hL_UserDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_User.HL_UserDataTable GetUserPrePageList(string tblName, string strGetFields, string fldName, int? PageSize, int? PageIndex, int? OrderType, string strWhere, int? Counts)
		{
			this.Adapter.SelectCommand = this.CommandCollection[18];
			if (tblName == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = tblName;
			}
			if (strGetFields == null)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = strGetFields;
			}
			if (fldName == null)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = fldName;
			}
			if (PageSize.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[4].Value = PageSize.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[4].Value = System.DBNull.Value;
			}
			if (PageIndex.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[5].Value = PageIndex.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[5].Value = System.DBNull.Value;
			}
			if (OrderType.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[6].Value = OrderType.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[6].Value = System.DBNull.Value;
			}
			if (strWhere == null)
			{
				this.Adapter.SelectCommand.Parameters[7].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[7].Value = strWhere;
			}
			if (Counts.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[8].Value = Counts.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[8].Value = System.DBNull.Value;
			}
			H_User.HL_UserDataTable hL_UserDataTable = new H_User.HL_UserDataTable();
			this.Adapter.Fill(hL_UserDataTable);
			return hL_UserDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_User.HL_UserDataTable GetUsersByGroupID(int? GroupID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[19];
			if (GroupID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = GroupID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			H_User.HL_UserDataTable hL_UserDataTable = new H_User.HL_UserDataTable();
			this.Adapter.Fill(hL_UserDataTable);
			return hL_UserDataTable;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(H_User.HL_UserDataTable dataTable)
		{
			return this.Adapter.Update(dataTable);
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(H_User dataSet)
		{
			return this.Adapter.Update(dataSet, "HL_User");
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(DataRow dataRow)
		{
			return this.Adapter.Update(new DataRow[]
			{
				dataRow
			});
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(DataRow[] dataRows)
		{
			return this.Adapter.Update(dataRows);
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual object CheckUserEmailExist(string Email)
		{
			SqlCommand sqlCommand = this.CommandCollection[2];
			if (Email == null)
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = Email;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			object obj;
			try
			{
				obj = sqlCommand.ExecuteScalar();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			object result;
			if (obj == null || obj.GetType() == typeof(System.DBNull))
			{
				result = null;
			}
			else
			{
				result = obj;
			}
			return result;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual object CheckUserNameExist(string UserName)
		{
			SqlCommand sqlCommand = this.CommandCollection[3];
			if (UserName == null)
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = UserName;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			object obj;
			try
			{
				obj = sqlCommand.ExecuteScalar();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			object result;
			if (obj == null || obj.GetType() == typeof(System.DBNull))
			{
				result = null;
			}
			else
			{
				result = obj;
			}
			return result;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int? CountUserOnLine()
		{
			SqlCommand sqlCommand = this.CommandCollection[4];
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			object obj;
			try
			{
				obj = sqlCommand.ExecuteScalar();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			int? result;
			if (obj == null || obj.GetType() == typeof(System.DBNull))
			{
				result = null;
			}
			else
			{
				result = new int?((int)obj);
			}
			return result;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int PR_AdminUser(string UserIDArray, string Type)
		{
			SqlCommand sqlCommand = this.CommandCollection[20];
			if (UserIDArray == null)
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = UserIDArray;
			}
			if (Type == null)
			{
				sqlCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[2].Value = Type;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int PR_UpdatePayMoney(int? OrderFormID, int? BuyerID, int? SalerID, decimal? PayMoney, string Sender_moneyKey, string Receiver_moneyKey)
		{
			SqlCommand sqlCommand = this.CommandCollection[21];
			if (OrderFormID.HasValue)
			{
				sqlCommand.Parameters[1].Value = OrderFormID.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (BuyerID.HasValue)
			{
				sqlCommand.Parameters[2].Value = BuyerID.Value;
			}
			else
			{
				sqlCommand.Parameters[2].Value = System.DBNull.Value;
			}
			if (SalerID.HasValue)
			{
				sqlCommand.Parameters[3].Value = SalerID.Value;
			}
			else
			{
				sqlCommand.Parameters[3].Value = System.DBNull.Value;
			}
			if (PayMoney.HasValue)
			{
				sqlCommand.Parameters[4].Value = PayMoney.Value;
			}
			else
			{
				sqlCommand.Parameters[4].Value = System.DBNull.Value;
			}
			if (Sender_moneyKey == null)
			{
				sqlCommand.Parameters[5].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[5].Value = Sender_moneyKey;
			}
			if (Receiver_moneyKey == null)
			{
				sqlCommand.Parameters[6].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[6].Value = Receiver_moneyKey;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
	}
}
